USE [vudu]
GO
/****** Object:  StoredProcedure [dbo].[ConsultaListaSeccionMateria]    Script Date: 05/27/2011 05:38:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[ConsultaListaSeccionMateria] 
	@prematricula int

AS
BEGIN

	SET NOCOUNT ON;
		SELECT fk_SeccionMateria, fk_Practica
		FROM dbo.EstudianteHorario
		WHERE  fk_HorarioPreMatricula = @prematricula
    
END
